Skip to main content Skip to complementary content

Supported source endpoints

This section lists the source endpoint versions supported by Replicate, according to endpoint type.

Cloud-based

Supported Cloud-based sources
Endpoint Supported versions

Windows

Red Hat Linux

Amazon Aurora MySQL

Supported via the MySQL source endpoint.

Same as the MySQL source endpoint.

AWS Aurora Cloud for PostgreSQL

Same as the PostgreSQL source

Amazon RDS for MySQL

Same as the MySQL source endpoint.

Amazon RDS for MariaDB

Supported via the MySQL source endpoint.

Same as the MySQL source endpoint

Amazon RDS for PostgreSQL

Same as the PostgreSQL source endpoint.

Amazon RDS for SQL Server

Same as the Microsoft SQL Server source endpoint (starting from 2014)

Amazon RDS for Oracle

Supported via the Oracle source endpoint.

Same as the Oracle source endpoint (starting from 11.2)

Google Cloud SQL for MySQL

Same as the MySQL source endpoint

Google Cloud SQL for PostgreSQL

Same as the PostgreSQL source endpoint

Google Cloud SQL for SQL Server

Same as the Microsoft SQL Server source endpoint

Google Cloud AlloyDB for PostgreSQL Same as the PostgreSQL source endpoint

Microsoft Azure SQL Managed Instance

  • Use the Microsoft Azure SQL (MS-CDC) endpoint to capture changes using MS-CDC. This is the recommended method of capturing changes.
  • Use the Microsoft Azure SQL Managed Instance endpoint to capture changes from the logs.

Same as the Microsoft SQL Server source endpoint.

Microsoft Azure SQL Database

Supported via the Microsoft Azure SQL (MS-CDC) endpoint.

Same as the Microsoft SQL Server source endpoint.

Microsoft Azure Database for MySQL

Same as the MySQL source endpoint (starting from 8.0)

Microsoft Azure Database for MySQL - Flexible Server

Supported via the MySQL source endpoint.

N/A

Microsoft Azure Database for PostgreSQL

Supported via the PostgreSQL source endpoint.

Same as the PostgreSQL source endpoint

Microsoft Azure Database for PostgreSQL - Flexible Server

Supported via the PostgreSQL source endpoint.

N/A

MongoDB Atlas

Supported via the MongoDB (Standard) source endpoint.

Same as the MongoDB (Standard) source endpoint.

Oracle on Oracle Cloud

Supported via the Oracle source endpoint.

Same as the Oracle source endpoint (starting from 11.2)

Salesforce (Streaming CDC)

N/A

Salesforce (Incremental Load)

N/A

ARC-based

Supported ARC-based sources
Endpoint Supported Versions

Windows

Red Hat Linux

IBM IMS (ARC)

IBM z/OS:

2.3 and 2.4

IMS:

13, 14, and 15.x

IBM VSAM Batch (ARC)

IBM z/OS:

2.3

File

Supported file-based sources
Endpoint Supported Versions

Windows

Red Hat Linux

File

N/A

File Channel

N/A

Relational databases

Supported relational database sources
Endpoint Supported Versions

Windows

Red Hat Linux

IBM DB2 for LUW

10.5, 11.1, and 11.5

Information note

10.5 with fix pack 5 is not supported.

IBM DB2 for z/OS

DB2:

12.1 and 13.1

IBM z/OS:

2.3, 2.4, and 2.5

IBM DB2 for iSeries

7.2, 7.3, 7.4, and 7.5

IBM Informix

12.1 and 14.10

 

Microsoft SQL Server

2014, 2016, 2017, 2019, and 2022

Microsoft SQL Server (MS-CDC)

2014, 2016, 2017, 2019, and 2022

MySQL

5.7 and 8.0

MariaDB

Supported via the MySQL source endpoint.

10.4 to 10.11

Percona

Supported via the MySQL source endpoint.

Same as the MySQL source endpoint

X

Oracle

12.x, 18.x, 19.x, and 21c

Warning noteIf you set the Oracle compatibility parameter, make sure you specify a version supported by Replicate. For example, if you are working with version 12.x, you cannot set an earlier version as the compatibility version.

PostgreSQL

11.x, 12.x, 13.x, 14.x, and 15.x

SAP Sybase ASE

16

SAP HANA

2.0

Data warehouses

Supported data warehouse sources
Endpoint Supported Versions

Windows

Red Hat Linux

Teradata Database

17.x

ODBC

Information note

The ODBC and ODBC with CDC source endpoints can be used to access sources that are not included in Qlik Replicate’s extensive Support Matrix. However, unless enabled through Professional Services and approved by your Account Manager, ODBC source endpoint types should not be used. Additionally, ODBC source endpoint types should not be used to access any sources already listed in the Support Matrix.

Supported ODBC sources
Endpoint Supported Versions

Windows

Red Hat Linux

ODBC

3.0, 3.5 and 3.8

ODBC with CDC

3.0, 3.5 and 3.8

NoSQL

Supported NoSQL sources
Endpoint Supported Versions

Windows

Red Hat Linux

MongoDB (Standard)

4.4, 5.x, and 6.x

Other

Other supported sources
Endpoint Supported Versions

Windows

Red Hat Linux

SAP Application

Supported backend endpoints:

See Relational Databases above for version and platform information.

SAP Application (DB)

Supported backend endpoints:

  • Oracle

    Information note

    When using Oracle as the backend database, any tables you want to capture must be defined with ALL COLUMN SUPPLEMENTAL LOGGING.

    See also: Using Oracle as a source

  • Microsoft SQL Server

    Information note

    When using Microsoft SQL Server as the backend database, transparent table fields defined as STRING or BINARY STRING are not supported.

    See also: Using Microsoft SQL Server as a source

  • IBM DB2 for LUW

    See also: Using IBM DB2 for LUW as a source

  • IBM DB2 for z/OS

    See also: Using IBM DB2 for z/OS as a source

  • SAP HANA

    Information note

    When using SAP HANA as the backend database, the following limitations apply when the SAP HANA endpoint is configured to use Log-based CDC mode:

    • Replicate creates a hana__row_id column on the target as a Unique Index and changes the original Primary Key/Unique Index to a standard column.
    • Table DDLs are not supported and will be ignored
    • Replication of transparent tables only is supported
    • The Apply Conflicts error-handling policy for No record found for applying DELETE and No record found for applying an UPDATE must be st to Ignore record.

    See also: Using SAP HANA as a source

See Relational Databases above for version and platform information.

SAP Extractor N/A

SAP ODP

The SAP ODP endpoint uses ODP API 2.0 which is available from the following SAP basis levels and above:

  • PI_BASIS 730 SP 14 (part of SAP NetWeaver 7.30 SP 14)

  • PI_BASIS 731 SP 16 (part of SAP NetWeaver 7.03 SP 16 and 7.31 SP 16)

  • PI_BASIS 740 SP 11 (part of SAP NetWeaver 7.40 SP 11)

  • SAP_BW 750 SP 0 (incl. former PI_BASIS packages)

Information noteSAP_BASIS and PI_BASIS are interchangeable. In newer systems, the component name is SAP_BASIS.

For more information, see SAP Note 1931427.

For information on how to release extractors so that they are available for the ODP API, see SAP Note 2232584.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!